Overview

Dataset Statistics

Number of Variables 18
Number of Rows 6888
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 787.0 KB
Average Row Size in Memory 117.0 B
Variable Types
  • Numerical: 10
  • Categorical: 8

Dataset Insights

Open and High have similar distributions Similar Distribution
Open and Low have similar distributions Similar Distribution
Open and Close have similar distributions Similar Distribution
High and Low have similar distributions Similar Distribution
High and Close have similar distributions Similar Distribution
Low and Close have similar distributions Similar Distribution
Open is skewed Skewed
High is skewed Skewed
Low is skewed Skewed
Close is skewed Skewed
returns is skewed Skewed
cum_returns is skewed Skewed
Dividends has constant value "0.0" Constant
Stock Splits has constant value "0.0" Constant
Hour has constant value "0" Constant
Dividends has constant length 3 Constant Length
Stock Splits has constant length 3 Constant Length
wkDay_Friday has constant length 1 Constant Length
wkDay_Monday has constant length 1 Constant Length
wkDay_Thursday has constant length 1 Constant Length
wkDay_Tuesday has constant length 1 Constant Length
wkDay_Wednesday has constant length 1 Constant Length
Hour has constant length 1 Constant Length
returns has 3199 (46.44%) negatives Negatives
  • 1
  • 2
  • 3

Variables


Open

numerical

Approximate Distinct Count 6748
Approximate Unique (%) 98.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 1932.4496
Minimum 679.28
Maximum 5441.9302
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Open is skewed right (γ1 = 1.2864)

Quantile Statistics

Minimum 679.28
5-th Percentile 893.692
Q1 1155.3125
Median 1403.885
Q3 2451.7349
95-th Percentile 4403.366
Maximum 5441.9302
Range 4762.6501
IQR 1296.4224

Descriptive Statistics

Mean 1932.4496
Standard Deviation 1110.3312
Variance 1.2328e+06
Sum 1.3311e+07
Skewness 1.2864
Kurtosis 0.5564
Coefficient of Variation 0.5746
  • Open is not normally distributed (p-value 2.0020749621508827e-08)
  • Open has 349 outliers

High

numerical

Approximate Distinct Count 6728
Approximate Unique (%) 97.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 1943.8939
Minimum 695.27
Maximum 5447.25
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • High is skewed right (γ1 = 1.2877)

Quantile Statistics

Minimum 695.27
5-th Percentile 904.911
Q1 1163.7
Median 1411.765
Q3 2465.7774
95-th Percentile 4422.6915
Maximum 5447.25
Range 4751.98
IQR 1302.0774

Descriptive Statistics

Mean 1943.8939
Standard Deviation 1115.4748
Variance 1.2443e+06
Sum 1.339e+07
Skewness 1.2877
Kurtosis 0.5532
Coefficient of Variation 0.5738
  • High is not normally distributed (p-value 2.445472754253491e-08)
  • High has 350 outliers

Low

numerical

Approximate Distinct Count 6737
Approximate Unique (%) 97.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 1920.2234
Minimum 666.79
Maximum 5409.1299
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Low is skewed right (γ1 = 1.2851)

Quantile Statistics

Minimum 666.79
5-th Percentile 882.5235
Q1 1144.9
Median 1396.23
Q3 2441.2399
95-th Percentile 4382.2695
Maximum 5409.1299
Range 4742.3399
IQR 1296.34

Descriptive Statistics

Mean 1920.2234
Standard Deviation 1104.8843
Variance 1.2208e+06
Sum 1.3226e+07
Skewness 1.2851
Kurtosis 0.5597
Coefficient of Variation 0.5754
  • Low is not normally distributed (p-value 2.4809179652524303e-08)
  • Low has 340 outliers

Close

numerical

Approximate Distinct Count 6742
Approximate Unique (%) 97.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 1932.8293
Minimum 676.53
Maximum 5433.7402
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Close is skewed right (γ1 = 1.2867)

Quantile Statistics

Minimum 676.53
5-th Percentile 894.532
Q1 1155.4375
Median 1403.905
Q3 2454.4925
95-th Percentile 4401.173
Maximum 5433.7402
Range 4757.2102
IQR 1299.055

Descriptive Statistics

Mean 1932.8293
Standard Deviation 1110.5816
Variance 1.2334e+06
Sum 1.3313e+07
Skewness 1.2867
Kurtosis 0.5573
Coefficient of Variation 0.5746
  • Close is not normally distributed (p-value 2.6252779661544335e-08)
  • Close has 341 outliers

Volume

numerical

Approximate Distinct Count 6695
Approximate Unique (%) 97.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 3.0542e+09
Minimum 154900000
Maximum 11456230000
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Volume is skewed right (γ1 = 0.3883)

Quantile Statistics

Minimum 154900000
5-th Percentile 6.3637e+08
Q1 1.4737e+09
Median 3.3051e+09
Q3 4.0559e+09
95-th Percentile 5.7234e+09
Maximum 11456230000
Range 11301330000
IQR 2.5822e+09

Descriptive Statistics

Mean 3.0542e+09
Standard Deviation 1.6399e+09
Variance 2.6893e+18
Sum 2.1037e+13
Skewness 0.3883
Kurtosis 0.1811
Coefficient of Variation 0.5369
  • Volume has 47 outliers

Dividends

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 468384

Length

Mean 3
Standard Deviation 0
Median 3
Minimum 3
Maximum 3

Sample

1st row 0.0
2nd row 0.0
3rd row 0.0
4th row 0.0
5th row 0.0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 13776
  • Dividends has words of constant length

Stock Splits

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 468384

Length

Mean 3
Standard Deviation 0
Median 3
Minimum 3
Maximum 3

Sample

1st row 0.0
2nd row 0.0
3rd row 0.0
4th row 0.0
5th row 0.0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 13776
  • Stock Splits has words of constant length

returns

numerical

Approximate Distinct Count 6886
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 0.00035615
Minimum -0.1198
Maximum 0.1158
Zeros 3
Zeros (%) 0.0%
Negatives 3199
Negatives (%) 46.4%
  • returns is skewed left (γ1 = -0.1751)

Quantile Statistics

Minimum -0.1198
5-th Percentile -0.01855
Q1 -0.00494
Median 0.00064529
Q3 0.006141
95-th Percentile 0.01755
Maximum 0.1158
Range 0.2356
IQR 0.01108

Descriptive Statistics

Mean 0.00035615
Standard Deviation 0.01225
Variance 0.00015
Sum 2.4532
Skewness -0.1751
Kurtosis 9.5201
Coefficient of Variation 34.3884
  • returns is not normally distributed (p-value 4.2723237859711076e-13)
  • returns has 440 outliers

cum_returns

numerical

Approximate Distinct Count 6877
Approximate Unique (%) 99.8%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 1.4648
Minimum -0.1373
Maximum 5.9293
Zeros 0
Zeros (%) 0.0%
Negatives 49
Negatives (%) 0.7%
  • cum_returns is skewed right (γ1 = 1.2867)

Quantile Statistics

Minimum -0.1373
5-th Percentile 0.1407
Q1 0.4735
Median 0.7903
Q3 2.1301
95-th Percentile 4.6125
Maximum 5.9293
Range 6.0666
IQR 1.6566

Descriptive Statistics

Mean 1.4648
Standard Deviation 1.4163
Variance 2.0058
Sum 10089.6054
Skewness 1.2867
Kurtosis 0.5573
Coefficient of Variation 0.9669
  • cum_returns is not normally distributed (p-value 2.6252779661544335e-08)
  • cum_returns has 341 outliers

wkDay_Friday

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 454608
  • The largest value (0) is over 3.99 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 1
2nd row 0
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 6888
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 3.99 times larger than the second largest value (1)
  • wkDay_Friday has words of constant length

wkDay_Monday

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 454608
  • The largest value (0) is over 4.34 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 1
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 6888
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 4.34 times larger than the second largest value (1)
  • wkDay_Monday has words of constant length

wkDay_Thursday

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 454608
  • The largest value (0) is over 3.96 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 1

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 6888
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 3.96 times larger than the second largest value (1)
  • wkDay_Thursday has words of constant length

wkDay_Tuesday

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 454608
  • The largest value (0) is over 3.87 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 1
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 6888
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 3.87 times larger than the second largest value (1)
  • wkDay_Tuesday has words of constant length

wkDay_Wednesday

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 454608
  • The largest value (0) is over 3.86 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 1
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 6888
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 3.86 times larger than the second largest value (1)
  • wkDay_Wednesday has words of constant length

Year

numerical

Approximate Distinct Count 28
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 2010.2706
Minimum 1997
Maximum 2024
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Year is skewed right (γ1 = 0.002)

Quantile Statistics

Minimum 1997
5-th Percentile 1998
Q1 2003
Median 2010
Q3 2017
95-th Percentile 2023
Maximum 2024
Range 27
IQR 14

Descriptive Statistics

Mean 2010.2706
Standard Deviation 7.907
Variance 62.5212
Sum 1.3847e+07
Skewness 0.001998
Kurtosis -1.1966
Coefficient of Variation 0.003933
  • Year is not normally distributed (p-value 3.440005804837718e-240)

Month

numerical

Approximate Distinct Count 12
Approximate Unique (%) 0.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 6.508
Minimum 1
Maximum 12
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Month is skewed right (γ1 = 0.0074)

Quantile Statistics

Minimum 1
5-th Percentile 1
Q1 3
Median 6
Q3 9
95-th Percentile 12
Maximum 12
Range 11
IQR 6

Descriptive Statistics

Mean 6.508
Standard Deviation 3.4219
Variance 11.7095
Sum 44827
Skewness 0.007433
Kurtosis -1.1996
Coefficient of Variation 0.5258
  • Month is not normally distributed (p-value 0.0034677814828173023)

Day

numerical

Approximate Distinct Count 31
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 110208
Mean 15.7208
Minimum 1
Maximum 31
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Day is skewed right (γ1 = 0.0207)

Quantile Statistics

Minimum 1
5-th Percentile 2
Q1 8
Median 16
Q3 23
95-th Percentile 29
Maximum 31
Range 30
IQR 15

Descriptive Statistics

Mean 15.7208
Standard Deviation 8.7554
Variance 76.6569
Sum 108285
Skewness 0.02074
Kurtosis -1.1828
Coefficient of Variation 0.5569
  • Day is not normally distributed (p-value 5.023826142918863e-63)

Hour

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 454608

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 6888
  • Hour has words of constant length

Interactions

Correlations

Missing Values